/*
 Navicat Premium Data Transfer

 Source Server         : huangxu'Mac
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost
 Source Database       : ylmall

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : utf-8

 Date: 05/18/2020 11:04:58 AM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `refundinfo`
-- ----------------------------
DROP TABLE IF EXISTS `refundinfo`;
CREATE TABLE `refundinfo` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `reason` varchar(255) NOT NULL DEFAULT '' COMMENT '退款退货原因',
  `reason_id` int unsigned NOT NULL DEFAULT '0' COMMENT '1688退款原因',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '信息类型(1退款 2退货,默认1)',
  `album_id` int NOT NULL DEFAULT '0' COMMENT '凭证',
  `order_sn` varchar(50) NOT NULL DEFAULT '' COMMENT '订单编号 order中sn',
  `refund_order_id` varchar(100) NOT NULL DEFAULT '' COMMENT '退款、退货订单号(1688返回)',
  `logistics` longtext COMMENT '物流信息',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `member_id` int NOT NULL DEFAULT '0' COMMENT '创建人',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最近一次编辑时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_sn` (`order_sn`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='退货/退款原因信息表';

-- ----------------------------
--  Records of `refundinfo`
-- ----------------------------
BEGIN;
INSERT INTO `refundinfo` VALUES ('57', '圣诞节开发', '1', '1', '133', '202004141851230643318735', '0', 'a:5:{s:8:\"order_sn\";s:24:\"202004141851230643318735\";s:20:\"logistics_company_no\";s:1:\"1\";s:12:\"freight_bill\";s:10:\"3123asdsad\";s:11:\"description\";s:22:\"123123asdf阿斯蒂芬\";s:8:\"album_id\";s:3:\"137\";}', '2020-05-05 21:01:28', '0', '2020-05-18 10:44:59'), ('61', '我就是要退款', '1', '1', '111', '202004141851230643318736', 'TQ1688-orderId-1588584140', '', '2020-05-18 04:14:26', '6', '2020-05-18 11:03:41');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
